package com.guigu.www.erp.dehao.dao;

import com.guigu.www.erp.common.pojo.MManufacture;
import com.guigu.www.erp.common.pojo.MProcedureModule;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface MManufactureMapper {

    int insertSelective(MManufacture mManufacture);
    MManufacture selectByPrimaryKey(Integer id);
    int updateByPrimaryKeySelective(MManufacture mManufacture);


    int deleteByPrimaryKey(Integer id);
    int insert(MManufacture record);
    int updateByPrimaryKey(MManufacture record);

    String queryMaxManufacture();

    List<MManufacture> queryAllByCheckTag();

    //查询所有，不限状态
    List<MManufacture> queryAllMManufacture(@Param("productName") String productName,
                                            @Param("startTime") String startTime,
                                            @Param("endTime") String endTime);

    //查询三种状态的数量
    Integer queryByCheckTag0();
    Integer queryByCheckTag1();
    Integer queryByCheckTag2();

    //查询物料数量
    Integer queryModuleAmount(@Param("arr") String arr);
    Integer queryModuleSubtotal(@Param("arr") String arr);

    List<MManufacture> queryManufactureProcedureTag01();

    List<MManufacture> queryManufactureProcedureTag1();

    Integer queryByCheckTag01();
    Integer queryByCheckTag1AndProcedure1();

    List<MManufacture> findAllMManufactureByCheckTag1(String manufactureId);

    Integer queryManufactureCountBy12();
}